﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$LocalizationDBConnection$" formatter="bizobjlist of Translation(language)">
	<Sql>
		SELECT
			Languages.id as languageid,
			Languages.ISO6392 as languageiso6392, 
			Languages.regionCode as languageregionCode,
			Languages.englishName as languageenglishName,
			Languages.nativeName as languagenativeName,
			Translations.id,
			Translations.name
		FROM
			Languages
		INNER JOIN
			Translations ON Languages.id = Translations.languageId INNER JOIN
			CompanyTranslations ON Translations.id = CompanyTranslations.translationId
		WHERE
			(CompanyTranslations.companyId = @companyId)
	</Sql>
	<Param name="companyId" type="UniqueIdentifier" />
</AdoNetDataAccess>